package com.learn.project2.mapper;

import com.learn.project2.bean.MarketOrder;
import com.learn.project2.bean.MarketOrderExample;
import java.util.List;

import com.learn.project2.model.vo.admin.order.OrderChannelVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface MarketOrderMapper {
    long countByExample(MarketOrderExample example);

    int deleteByExample(MarketOrderExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(MarketOrder record);

    int insertSelective(MarketOrder record);

    List<MarketOrder> selectByExample(MarketOrderExample example);

    MarketOrder selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") MarketOrder record, @Param("example") MarketOrderExample example);

    int updateByExample(@Param("record") MarketOrder record, @Param("example") MarketOrderExample example);

    int updateByPrimaryKeySelective(MarketOrder record);

    int updateByPrimaryKey(MarketOrder record);

    List<OrderChannelVO> selectChannel();


    String[] selectDistinctDates();

    Double selectSumOfAmountsByDay(String day);

    Integer selectCustomersByDay(String day);

    Integer selectOrdersByDay(String day);
}